PCMania 32/PCMania CD32_2.iso/sharewar/varios/zodiac/consult2.md_/consult2.md

Text File | 1994-04-12 | 507b | 10 lines

SELECT  DISTINCTROW TbTime.FechaDeCambio, TbLocation.Localidad, TbTime.ZonaHoras, TbTime.HorasCambio
FROM TbLocation, TbTime,
TbLocation INNER JOIN TbTime ON TbLocation.Pais = TbTime.Pais,
TbLocation INNER JOIN TbTime ON TbLocation.TablaDeTiempo = TbTime.TablaDeTiempo
GROUP BY TbTime.FechaDeCambio, TbLocation.Localidad, TbTime.ZonaHoras, TbTime.HorasCambio
HAVING ((TbTime.FechaDeCambio>#08/13/60#) AND (TbLocation.Localidad="salamanca"))
ORDER BY TbTime.FechaDeCambio
WITH OWNERACCESS OPTION;